package db;


public class Db2NativeStatements extends AbstractDbNativeStatements {
	
	
	
	public String getAllColumnsSql(String schema, String table) {
		return " SELECT column_name AS COLUMN_NAME, data_type AS DATA_TYPE" +
						" FROM  all_tab_columns" +
						" WHERE owner = '" + schema.toUpperCase() + "'" +
						"    AND table_name = '" + table + "'";
	}

	@Override
	public String getAllTablesSql(String schema) {
		return " SELECT tabname AS TABLE_NAME " +
		  " FROM syscat.tables " +
		  " WHERE tabschema = '" + schema.toUpperCase() + "'";
	}

	@Override
	public String getPrimaryKeyColumns(String schema, String table) {
		// TODO Auto-generated method stub
		return null;
	}

	@Override
	public String getReferencesSql(String schema, String table) {
		// TODO Auto-generated method stub
		return null;
	}

	@Override
	public String getIndexesSql(String schema, String table) {
		// TODO Auto-generated method stub
		return null;
	}

}
